﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using XBLib.Dal;
using XBLib.Dal.AdoDal;
using XBLib.BusinessObject;

using System.Data.Common;
using DataInfo;
namespace KenLib.Dal
{
    class 事業内容Dao : BaseAdoDao
    {
        #region TUNG
        public DataTable get事業内容()
        {
            //DbParameter dbParam種類コード = _daoHelper.CreateParameter("@種類コード", 種類コード, DbType.Int32);
            DbCommand dbcommand = _daoHelper.CreateCommand("sp_get事業内容_TUNG", CommandType.StoredProcedure);
            return _daoHelper.Query(dbcommand);
        }
        public DataTable get事業内容ID(string name)
        {
            DbParameter dbParam1 = _daoHelper.CreateParameter("@Name", name, DbType.String);
            DbCommand dbcommand = _daoHelper.CreateCommand("sp_get事業内容ID_TUNG", CommandType.StoredProcedure, dbParam1);
            return _daoHelper.Query(dbcommand);
        }

        public DataTable get事業内容Name(int ID)
        {
            DbParameter dbParam1 = _daoHelper.CreateParameter("@ID", ID, DbType.Int32);
            DbCommand dbcommand = _daoHelper.CreateCommand("sp_get事業内容NAME_TUNG", CommandType.StoredProcedure, dbParam1);
            return _daoHelper.Query(dbcommand);
        }

        #endregion

        #region Vhoat
        public DataTable select事業内容ColumnPartial_59(int id種類コード)
        {
            DbCommand com = null;
            try
            {
                com = _daoHelper.CreateCommand(CommandNameManager.select事業内容Column_Partial_59, CommandType.StoredProcedure);
                DbParameter para1  =_daoHelper.CreateParameter("@種類コード", id種類コード);
                com.Parameters.Add(para1);
            }
            catch (Exception ex) { }

            return _daoHelper.Query(com);
        }

      
        
        public DataTable frmJ_IntroCompBasicInput_Select(int id)
        {
            DbParameter para = _daoHelper.CreateParameter("@ID", id, DbType.Int32);
            DbCommand com = _daoHelper.CreateCommand("sp_frmJ_IntroCompBasicInput_Select_Dong", CommandType.StoredProcedure);
            com.Parameters.Add(para);
            return _daoHelper.Query(com);
        }
        #endregion

        
        #region Thanh Dong
        //Get data for ddl_経験作業名1, ddl_経験作業名2, ddl_経験作業名3
        public DataTable frmJ_TraineeResumeBInput_Select()
        {
            DbCommand dbcommand = _daoHelper.CreateCommand(CommandNameManager.sp_frmJ_TraineeResumeBInput_Select_Dong, CommandType.StoredProcedure);
            return _daoHelper.Query(dbcommand);
        }
        public DataTable frmJ_TraineeListSelect_事業内容(int 経験作業名)
        {
            DbParameter dbparam = _daoHelper.CreateParameter("@経験作業名", 経験作業名, DbType.Int32);
            DbCommand dbcommand = _daoHelper.CreateCommand(CommandNameManager.sp_frmJ_TraineeListSelect_事業内容_Dong, CommandType.StoredProcedure, dbparam);
            return _daoHelper.Query(dbcommand);
        }

        public DataTable frmJ_TraineeSearch_Select_ddl_経験作業名()
        {
            DbCommand dbcommand = _daoHelper.CreateCommand(CommandNameManager.sp_frmJ_TraineeSearch_Select_ddl_経験作業名_Dong, CommandType.StoredProcedure);
            return _daoHelper.Query(dbcommand);
        }
        #endregion

        #region Hunglt
        public DataTable frmO_BasicInfoInput_Select_事業内容()
        {
            DbCommand dbcommand = _daoHelper.CreateCommand("select_frmO_BasicInfoInput_事業内容_Hunglt", CommandType.StoredProcedure);
            return _daoHelper.Query(dbcommand);
        }
        #endregion
    }
}
